Influenza Data Activity and Claim Form

Created for Northern Ireland Vision 3 practices

The Influenza Data Activity and Claim Form is an auto-populating claim form in Excel which can simply be printed and submitted.

The only counts that need to be manually input are the under 65's risk reasons, which maybe verified from the Excel report 'Under 65" sheet. The final count for these risk reasons should equal the total. If not it displays (under the Total) on the sheet as either a negative count or positive count if there are too many.

The report also provides evidence sheets of all the immunisations.

Download

Updates

  • Updated 17/06/2019 v2.3 - Fix: Formulas on 'Claim' sheet now cater for no data found. Previously a count of one was added against a named range even thought it was empty.
  • Updated 07/11/2018 v2.2 - "No of vaccines used between" now includes intranasal count on Claims sheet Fix: It was missing patients on claim form that were under 65 given Intranasal that are not either Pre or Primary school ages.
  • Updated 06/11/2018 v2.1 - Now uses the Primary and Pre-School DOB to calculate patients, rather than the Age. "Notes Kept At" added to tables. Reference date added to work out those aged 65y
  • Updated 24/09/2018 v1.1 - Now includes patient address details.
Note – To print this topic select Print in the top right corner and follow the on-screen prompts.